﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_DispatchItem') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_DispatchItem
END
GO
create view V_DispatchItem
as select 
[Guid]
,[ItemValue]
,[ItemCode]
,[DispatchMode]
from [ShopNum1_DispatchItem] A where A.IsDeleted=0